package com.xjj.datarources.dao;

import com.xjj.datarources.vo.Admininfo;
import com.xjj.datarources.vo.MysqlVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;
import java.util.Map;

/**
 * @name: xjj
 * @date: 2021/5/19 22:37
 */

public interface SQLMapper {


    @Select("select empno, empid, empname from ba_admininfo")
    List<Admininfo> getIds();



    @Select("select id, name from name")
    List<MysqlVo> getNames();


    @Update("update name set name = 'sb' where id =#{id}")
    void updateById(@Param("id") String id);

    @Select("${sql}")
    List<Map<String, Object>> query(@Param("sql") String sql);





}
